import excel "${hmrc_datadir}\CBT\tax havens.xlsx", sheet("Sheet1") firstrow clear
rename D OECD_havens
rename WorldBankTaxHavenHinesRice Hines_havens
rename Code alpha3code
merge 1:m alpha3code using "${hmrc_datadir}\export_reg_final_ukmncs_fy_ntrans"
tab alpha3code if _merge==3
drop if _merge==1
replace OECD_havens=0 if OECD_havens==.
replace Hines_havens=0 if Hines_havens==.
save "${hmrc_datadir}\export_reg_final_ukmncs_fy_ntrans_newhavens", replace 


